<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh">
<head>
<title>源代码</title>
<link rel="stylesheet" type="text/css" href="../../../../../../stylesheet.css" title="Style">
</head>
<body>
<div class="sourceContainer">
<pre><span class="sourceLineNo">001</span>package org.teapot.db.orm.mdl;<a name="line.1"></a>
<span class="sourceLineNo">002</span><a name="line.2"></a>
<span class="sourceLineNo">003</span>import org.teapot.db.orm.util.UModelConstant;<a name="line.3"></a>
<span class="sourceLineNo">004</span><a name="line.4"></a>
<span class="sourceLineNo">005</span>import java.util.ArrayList;<a name="line.5"></a>
<span class="sourceLineNo">006</span>import java.util.List;<a name="line.6"></a>
<span class="sourceLineNo">007</span><a name="line.7"></a>
<span class="sourceLineNo">008</span>/**<a name="line.8"></a>
<span class="sourceLineNo">009</span> * order clause<a name="line.9"></a>
<span class="sourceLineNo">010</span> * ORDER BY 子句.<a name="line.10"></a>
<span class="sourceLineNo">011</span> * @author DBJ<a name="line.11"></a>
<span class="sourceLineNo">012</span> *<a name="line.12"></a>
<span class="sourceLineNo">013</span> */<a name="line.13"></a>
<span class="sourceLineNo">014</span>public class Orderby implements IClause {<a name="line.14"></a>
<span class="sourceLineNo">015</span>  /*<a name="line.15"></a>
<span class="sourceLineNo">016</span>   * ORDER BY { column-Name | ColumnPosition | Expression }<a name="line.16"></a>
<span class="sourceLineNo">017</span>   *     [ ASC | DESC ]<a name="line.17"></a>
<span class="sourceLineNo">018</span>   *     [ NULLS FIRST | NULLS LAST ] mysql 没有这功能<a name="line.18"></a>
<span class="sourceLineNo">019</span>   *<a name="line.19"></a>
<span class="sourceLineNo">020</span>   *     [ , column-Name | ColumnPosition | Expression<a name="line.20"></a>
<span class="sourceLineNo">021</span>   *     [ ASC | DESC ]<a name="line.21"></a>
<span class="sourceLineNo">022</span>   *     [ NULLS FIRST | NULLS LAST ]<a name="line.22"></a>
<span class="sourceLineNo">023</span>   *     ] *<a name="line.23"></a>
<span class="sourceLineNo">024</span>   */<a name="line.24"></a>
<span class="sourceLineNo">025</span>  private ArrayList&lt;OptOrder&gt; orderby = new ArrayList&lt;OptOrder&gt;();<a name="line.25"></a>
<span class="sourceLineNo">026</span><a name="line.26"></a>
<span class="sourceLineNo">027</span>  public Orderby(String col) {<a name="line.27"></a>
<span class="sourceLineNo">028</span>    this(col, UModelConstant.SORT_ASC);<a name="line.28"></a>
<span class="sourceLineNo">029</span>  }<a name="line.29"></a>
<span class="sourceLineNo">030</span><a name="line.30"></a>
<span class="sourceLineNo">031</span>  public Orderby(String col, int orde) {<a name="line.31"></a>
<span class="sourceLineNo">032</span>    this.orderby.add(new OptOrder(col, orde));<a name="line.32"></a>
<span class="sourceLineNo">033</span>  }<a name="line.33"></a>
<span class="sourceLineNo">034</span><a name="line.34"></a>
<span class="sourceLineNo">035</span>  public Orderby asc(String col) {<a name="line.35"></a>
<span class="sourceLineNo">036</span>    this.orderby.add(new OptOrder(col, UModelConstant.SORT_ASC));<a name="line.36"></a>
<span class="sourceLineNo">037</span>    return this;<a name="line.37"></a>
<span class="sourceLineNo">038</span>  }<a name="line.38"></a>
<span class="sourceLineNo">039</span><a name="line.39"></a>
<span class="sourceLineNo">040</span>  public Orderby dsc(String col) {<a name="line.40"></a>
<span class="sourceLineNo">041</span>    this.orderby.add(new OptOrder(col, UModelConstant.SORT_DSC));<a name="line.41"></a>
<span class="sourceLineNo">042</span>    return this;<a name="line.42"></a>
<span class="sourceLineNo">043</span>  }<a name="line.43"></a>
<span class="sourceLineNo">044</span><a name="line.44"></a>
<span class="sourceLineNo">045</span>  /**<a name="line.45"></a>
<span class="sourceLineNo">046</span>   * order.<a name="line.46"></a>
<span class="sourceLineNo">047</span>   * @param col 字段名<a name="line.47"></a>
<span class="sourceLineNo">048</span>   * @return 自身<a name="line.48"></a>
<span class="sourceLineNo">049</span>   * @deprecated 建议使用asc dsc.<a name="line.49"></a>
<span class="sourceLineNo">050</span>   */<a name="line.50"></a>
<span class="sourceLineNo">051</span>  public Orderby order(String col) {<a name="line.51"></a>
<span class="sourceLineNo">052</span>    this.orderby.add(new OptOrder(col));<a name="line.52"></a>
<span class="sourceLineNo">053</span>    return this;<a name="line.53"></a>
<span class="sourceLineNo">054</span>  }<a name="line.54"></a>
<span class="sourceLineNo">055</span><a name="line.55"></a>
<span class="sourceLineNo">056</span>  /**<a name="line.56"></a>
<span class="sourceLineNo">057</span>   * order.<a name="line.57"></a>
<span class="sourceLineNo">058</span>   * @param col 字段名<a name="line.58"></a>
<span class="sourceLineNo">059</span>   * @param orde 排序<a name="line.59"></a>
<span class="sourceLineNo">060</span>   * @return 自身<a name="line.60"></a>
<span class="sourceLineNo">061</span>   * @deprecated 建议使用asc dsc.<a name="line.61"></a>
<span class="sourceLineNo">062</span>   */<a name="line.62"></a>
<span class="sourceLineNo">063</span>  public Orderby order(String col, int orde) {<a name="line.63"></a>
<span class="sourceLineNo">064</span>    this.orderby.add(new OptOrder(col, orde));<a name="line.64"></a>
<span class="sourceLineNo">065</span>    return this;<a name="line.65"></a>
<span class="sourceLineNo">066</span>  }<a name="line.66"></a>
<span class="sourceLineNo">067</span><a name="line.67"></a>
<span class="sourceLineNo">068</span>  public List&lt;OptOrder&gt; orderby() {<a name="line.68"></a>
<span class="sourceLineNo">069</span>    return this.orderby;<a name="line.69"></a>
<span class="sourceLineNo">070</span>  }<a name="line.70"></a>
<span class="sourceLineNo">071</span>}<a name="line.71"></a>




























































</pre>
</div>
</body>
</html>
